<html><head><title>when using "if update" (insert or update trigger)</title><meta name="HandheldFriendly" content="True"></head><body>when using "if update" (insert or update trigger)<br><br><b>create</b> <b>trigger</b> [owner.]trigger <b>on</b> [owner.]table <b>for</b> {<b>insert</b>, <b>update</b>} <b>as</b> [<b>if</b> <b>update</b>(column) [{<b>and</b> | <b>or</b>} <b>update</b>(column)]...] SQL_statements [<b>if</b> <b>update</b>(column) [{<b>and</b> | <b>or</b>} <b>update</b> (column)]... SQL_statements]...</body></html>